|
Courses >
Computer Applications > Intermediate Microsoft Excel 2003
 Have you been using Excel 2003 to its fullest potential? Learn how to work faster and more productively. Discover how the Pivot Table and AutoFilter can help you rapidly create reports and analyses. Learn advanced graphing techniques and how to use functions to get Excel 2003 to perform complex math, make decisions, and look up values in a table.
This course includes a knowledgeable and caring instructor who will guide you through your lessons, facilitate discussions, and answer your questions. The instructor for this course will be Craig Power.
 Craig Power has worked in adult continuing education for more than 18 years. A UCLA graduate, he created custom accounting software for state and local governments; developed an online course delivery and marketing platform currently used by more than 1,500 colleges and universities in the US, Canada, and Australia; developed an interactive cellular biology video for the Los Angeles Unified School District; taught college-level information technology courses; started and grew a thriving small business; and served as an executive with a large academic publishing corporation.
To purchase this course, click the Enroll Now button below:
Requirements:
Completion of Craig Power's online Introduction to Microsoft Excel 2003 course (or equivalent experience), Microsoft Windows XP or 2000, Microsoft Excel 2003 or Microsoft Office 2003 (Student and Teacher Edition, Standard Edition, Small Business Edition, or Professional Edition are all acceptable - please be sure to install the software on your computer before the course begins), Internet access, e-mail, and the Microsoft Internet Explorer or Mozilla Firefox Web browser.
This course is not suitable for Macintosh users, nor for users of any of the 2007 versions of Microsoft Excel.
Syllabus:
All courses run for six weeks, with a two-week grace period at the end. Two lessons are released each week for the six-week duration of the course. You do not have to be present when the lesson is released, but you must complete each lesson within two weeks of its release.
A new section of each course starts on the second or third Wednesday of each month. If enrolling in a series of two or more courses, please be sure to space the start date for each course at least two months apart.
| Week One |
| Wednesday - Lesson 01 |
Charting Fundamentals
|
| Friday - Lesson 02 |
Advanced Charting
|
| Week Two |
| Wednesday - Lesson 03 |
Data Management
|
| Friday - Lesson 04 |
AutoFilter; Goal Seeking
|
| Week Three |
| Wednesday - Lesson 05 |
The Pivot Table: Part 1
|
| Friday - Lesson 06 |
The Pivot Table: Part 2
|
| Week Four |
| Wednesday - Lesson 07 |
The Solver: Part 1
|
| Friday - Lesson 08 |
The Solver: Part 2
|
| Week Five |
| Wednesday - Lesson 09 |
Macros
|
| Friday - Lesson 10 |
Text Functions
|
| Week Six |
| Wednesday - Lesson 11 |
Math Functions
|
| Friday - Lesson 12 |
Lookup Functions
|
To purchase this course, click the Enroll Now button below:
Student Reviews:
"After completing both the Intro & the Intermediate Excel courses, the financial management of my company from now on will be a breeze! Thank you for a great opportunity to learn the advanced skills that I needed!"
"Craig Power has written this course to be clear and concise. His writing style conveys casualness yet it respects the reader's intellect, which established then maintained my interest throughout the past 6 weeks."
"He is an excellent instructor and walks you through each step thoroughly. You can tell he is passionate about teaching and is well versed with the subject matter. His sense of humor is right on."
"I enjoyed the taking the course, and each lesson, very informative and useful in the real world usage with timely and up to date information in every lesson and tip. Well worth recommending to others. Outstanding."
"I found this course to be very interesting and a challenge at the same time. Mr. Power lays this course out so that you can see what you have done wrong if you make any mistakes. I will be signing up for the Advanced Course."
"I have found this course, as well as the beginning Excel, to be a good reference tool. I'm not required to use Excel regularly on my job, so having the printed lessons and quizzes at my disposal, allow me to reference the material and to solve Excel problems when they arise."
"I really enjoyed the course. I got so excited about what I had learned after some of the lessons I could hardly wait to try them out in my own spreadsheets. Thank you so very much for making this understandable and easy to follow. It was great!"
"Overall, the course was great and will really help me in my current position. Thank you for the great program."
"This is an excellent course, which exceeded my expectations. The material was well organized and easy to follow. The instructor’s clear writing style and humor made the material easy to read, and his responses to questions were very prompt, friendly and thorough. Very encouraging!"
"Very interesting course. I've used what I've learned in this course at work and I've impressed many people with my new knowledge of excel. I definitely feel more comfortable using excel at work."
To purchase this course, click the Enroll Now button below:
Recommended Courses:
Students who enrolled in Intermediate Microsoft Excel 2003 were also interested in the following courses:
Advanced Microsoft Excel 2003
Creating a Successful Business Plan
Introduction to Microsoft Access 2003
Introduction to Business Analysis
Introduction to Microsoft Excel 2003
Performing Payroll in QuickBooks 2007
|
